Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 126079 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 32.9 MiB |
| Average record size in memory | 273.5 B |
Variable types
| Categorical | 14 |
|---|---|
| Numeric | 10 |
| Text | 5 |
Benefit per order is highly overall correlated with Order Item Total and 3 other fields | High correlation |
Category Name is highly overall correlated with Customer Id and 4 other fields | High correlation |
Customer Country is highly overall correlated with Customer State | High correlation |
Customer Id is highly overall correlated with Category Name | High correlation |
Customer State is highly overall correlated with Customer Country | High correlation |
Days for shipment (scheduled) is highly overall correlated with Days for shipping (real) and 1 other fields | High correlation |
Days for shipping (real) is highly overall correlated with Days for shipment (scheduled) and 3 other fields | High correlation |
Delivery Status is highly overall correlated with Days for shipping (real) and 2 other fields | High correlation |
Department Name is highly overall correlated with Category Name and 2 other fields | High correlation |
Late_delivery_risk is highly overall correlated with Days for shipping (real) and 1 other fields | High correlation |
Market is highly overall correlated with Order Region | High correlation |
Order Item Product Price is highly overall correlated with Category Name and 2 other fields | High correlation |
Order Item Quantity is highly overall correlated with Sales | High correlation |
Order Item Total is highly overall correlated with Benefit per order and 3 other fields | High correlation |
Order Profit Per Order is highly overall correlated with Benefit per order and 3 other fields | High correlation |
Order Region is highly overall correlated with Market | High correlation |
Order Status is highly overall correlated with Delivery Status and 1 other fields | High correlation |
Product Price is highly overall correlated with Category Name and 2 other fields | High correlation |
Sales is highly overall correlated with Benefit per order and 5 other fields | High correlation |
Sales per customer is highly overall correlated with Benefit per order and 3 other fields | High correlation |
Shipping Mode is highly overall correlated with Days for shipment (scheduled) and 1 other fields | High correlation |
Type is highly overall correlated with Order Status | High correlation |
Days for shipping (real) has 3588 (2.8%) zeros | Zeros |
Order Item Discount has 6978 (5.5%) zeros | Zeros |
Reproduction
| Analysis started | 2024-09-19 09:50:53.403610 |
|---|---|
| Analysis finished | 2024-09-19 09:51:13.918477 |
| Duration | 20.51 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
Type
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| DEBIT | |
|---|---|
| TRANSFER | |
| PAYMENT | |
| CASH |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.1815052 |
| Min length | 4 |
Characters and Unicode
| Total characters | 779358 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PAYMENT |
|---|---|
| 2nd row | PAYMENT |
| 3rd row | PAYMENT |
| 4th row | PAYMENT |
| 5th row | PAYMENT |
Common Values
| Value | Count | Frequency (%) |
| DEBIT | 48513 | |
| TRANSFER | 34784 | |
| PAYMENT | 29131 | |
| CASH | 13651 | 10.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| debit | 48513 | |
| transfer | 34784 | |
| payment | 29131 | |
| cash | 13651 | 10.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 112428 | |
| T | 112428 | |
| A | 77566 | |
| R | 69568 | |
| N | 63915 | |
| D | 48513 | |
| B | 48513 | |
| I | 48513 | |
| S | 48435 | |
| F | 34784 | 4.5% |
| Other values (5) | 114695 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 779358 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 112428 | |
| T | 112428 | |
| A | 77566 | |
| R | 69568 | |
| N | 63915 | |
| D | 48513 | |
| B | 48513 | |
| I | 48513 | |
| S | 48435 | |
| F | 34784 | 4.5% |
| Other values (5) | 114695 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 779358 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 112428 | |
| T | 112428 | |
| A | 77566 | |
| R | 69568 | |
| N | 63915 | |
| D | 48513 | |
| B | 48513 | |
| I | 48513 | |
| S | 48435 | |
| F | 34784 | 4.5% |
| Other values (5) | 114695 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 779358 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 112428 | |
| T | 112428 | |
| A | 77566 | |
| R | 69568 | |
| N | 63915 | |
| D | 48513 | |
| B | 48513 | |
| I | 48513 | |
| S | 48435 | |
| F | 34784 | 4.5% |
| Other values (5) | 114695 |
Days for shipping (real)
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4977593 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 3588 |
| Zeros (%) | 2.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.6251132 |
|---|---|
| Coefficient of variation (CV) | 0.46461551 |
| Kurtosis | -1.0056934 |
| Mean | 3.4977593 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.081968234 |
| Sum | 440994 |
| Variance | 2.640993 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 2 | 39418 | |
| 3 | 20108 | |
| 6 | 20102 | |
| 4 | 19957 | |
| 5 | 19622 | |
| 0 | 3588 | 2.8% |
| 1 | 3284 | 2.6% |
| Value | Count | Frequency (%) |
| 0 | 3588 | 2.8% |
| 1 | 3284 | 2.6% |
| 2 | 39418 | |
| 3 | 20108 | |
| 4 | 19957 | |
| 5 | 19622 | |
| 6 | 20102 |
| Value | Count | Frequency (%) |
| 6 | 20102 | |
| 5 | 19622 | |
| 4 | 19957 | |
| 3 | 20108 | |
| 2 | 39418 | |
| 1 | 3284 | 2.6% |
| 0 | 3588 | 2.8% |
Days for shipment (scheduled)
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| 4 | |
|---|---|
| 2 | |
| 1 | |
| 0 | 6872 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 126079 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 4 | 75188 | |
| 2 | 24646 | 19.5% |
| 1 | 19373 | 15.4% |
| 0 | 6872 | 5.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4 | 75188 | |
| 2 | 24646 | 19.5% |
| 1 | 19373 | 15.4% |
| 0 | 6872 | 5.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 75188 | |
| 2 | 24646 | 19.5% |
| 1 | 19373 | 15.4% |
| 0 | 6872 | 5.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 126079 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 75188 | |
| 2 | 24646 | 19.5% |
| 1 | 19373 | 15.4% |
| 0 | 6872 | 5.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 126079 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 75188 | |
| 2 | 24646 | 19.5% |
| 1 | 19373 | 15.4% |
| 0 | 6872 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 126079 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 75188 | |
| 2 | 24646 | 19.5% |
| 1 | 19373 | 15.4% |
| 0 | 6872 | 5.5% |
Benefit per order
Real number (ℝ)
HIGH CORRELATION
| Distinct | 11882 |
|---|---|
| Distinct (%) | 9.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.608891 |
| Minimum | -56.060001 |
|---|---|
| Maximum | 119.51 |
| Zeros | 916 |
| Zeros (%) | 0.7% |
| Negative | 14591 |
| Negative (%) | 11.6% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | -56.060001 |
|---|---|
| 5-th percentile | -22.981 |
| Q1 | 10.56 |
| median | 29.120001 |
| Q3 | 53.150002 |
| 95-th percentile | 88.190002 |
| Maximum | 119.51 |
| Range | 175.57 |
| Interquartile range (IQR) | 42.590001 |
Descriptive statistics
| Standard deviation | 32.194877 |
|---|---|
| Coefficient of variation (CV) | 1.0185387 |
| Kurtosis | -0.03514385 |
| Mean | 31.608891 |
| Median Absolute Deviation (MAD) | 20.720001 |
| Skewness | 0.10426268 |
| Sum | 3985217.4 |
| Variance | 1036.5101 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 916 | 0.7% |
| 46.79999924 | 180 | 0.1% |
| 63.70000076 | 169 | 0.1% |
| 38.22000122 | 147 | 0.1% |
| 14.39999962 | 146 | 0.1% |
| 12 | 146 | 0.1% |
| 18 | 145 | 0.1% |
| 72 | 143 | 0.1% |
| 62.40000153 | 137 | 0.1% |
| 43.68000031 | 137 | 0.1% |
| Other values (11872) | 123813 |
| Value | Count | Frequency (%) |
| -56.06000137 | 1 | < 0.1% |
| -56.02000046 | 8 | |
| -56 | 1 | < 0.1% |
| -55.99000168 | 2 | < 0.1% |
| -55.97999954 | 1 | < 0.1% |
| -55.97000122 | 1 | < 0.1% |
| -55.95999908 | 1 | < 0.1% |
| -55.93999863 | 1 | < 0.1% |
| -55.91999817 | 1 | < 0.1% |
| -55.90999985 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 119.5100021 | 9 | |
| 119.5 | 17 | |
| 119.2900009 | 1 | < 0.1% |
| 119.0599976 | 2 | < 0.1% |
| 119.0500031 | 1 | < 0.1% |
| 118.8300018 | 8 | |
| 118.8199997 | 2 | < 0.1% |
| 118.8000031 | 18 | |
| 118.7900009 | 4 | < 0.1% |
| 118.7799988 | 12 |
Sales per customer
Real number (ℝ)
HIGH CORRELATION
| Distinct | 2391 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 132.40764 |
| Minimum | 7.4899998 |
|---|---|
| Maximum | 318.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 7.4899998 |
|---|---|
| 5-th percentile | 37.790001 |
| Q1 | 88 |
| median | 124.79 |
| Q3 | 179.98 |
| 95-th percentile | 242.5 |
| Maximum | 318.5 |
| Range | 311.01 |
| Interquartile range (IQR) | 91.979996 |
Descriptive statistics
| Standard deviation | 63.465626 |
|---|---|
| Coefficient of variation (CV) | 0.47931997 |
| Kurtosis | -0.52885893 |
| Mean | 132.40764 |
| Median Absolute Deviation (MAD) | 46.18 |
| Skewness | 0.26566341 |
| Sum | 16693823 |
| Variance | 4027.8857 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 116.9899979 | 1147 | 0.9% |
| 109.1900024 | 1143 | 0.9% |
| 107.8899994 | 1143 | 0.9% |
| 120.8899994 | 1141 | 0.9% |
| 97.48999786 | 1141 | 0.9% |
| 113.0899963 | 1139 | 0.9% |
| 123.4899979 | 1139 | 0.9% |
| 127.3899994 | 1136 | 0.9% |
| 106.5899963 | 1135 | 0.9% |
| 118.2900009 | 1133 | 0.9% |
| Other values (2381) | 114682 |
| Value | Count | Frequency (%) |
| 7.489999771 | 3 | < 0.1% |
| 7.989999771 | 3 | < 0.1% |
| 8.18999958 | 3 | < 0.1% |
| 8.289999962 | 3 | < 0.1% |
| 8.390000343 | 3 | < 0.1% |
| 8.470000267 | 15 | |
| 8.489999771 | 3 | < 0.1% |
| 8.659999847 | 29 | |
| 8.68999958 | 3 | < 0.1% |
| 8.789999962 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 318.5 | 2 | |
| 316.7600098 | 1 | < 0.1% |
| 315.25 | 3 | |
| 313.6000061 | 1 | < 0.1% |
| 313.5599976 | 1 | < 0.1% |
| 312 | 2 | |
| 310.3599854 | 1 | < 0.1% |
| 308.75 | 2 | |
| 307.2000122 | 1 | < 0.1% |
| 307.1600037 | 3 |
Delivery Status
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| Late delivery | |
|---|---|
| Advance shipping | |
| Shipping on time | |
| Shipping canceled | 5437 |
Length
| Max length | 17 |
|---|---|
| Median length | 13 |
| Mean length | 14.398441 |
| Min length | 13 |
Characters and Unicode
| Total characters | 1815341 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Late delivery |
|---|---|
| 2nd row | Late delivery |
| 3rd row | Shipping on time |
| 4th row | Late delivery |
| 5th row | Late delivery |
Common Values
| Value | Count | Frequency (%) |
| Late delivery | 69120 | |
| Advance shipping | 28982 | |
| Shipping on time | 22540 | 17.9% |
| Shipping canceled | 5437 | 4.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| late | 69120 | |
| delivery | 69120 | |
| shipping | 56959 | |
| advance | 28982 | |
| on | 22540 | 8.2% |
| time | 22540 | 8.2% |
| canceled | 5437 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 269756 | |
| i | 205578 | |
| 148619 | 8.2% | |
| n | 113918 | 6.3% |
| p | 113918 | 6.3% |
| d | 103539 | 5.7% |
| a | 103539 | 5.7% |
| v | 98102 | 5.4% |
| t | 91660 | 5.0% |
| l | 74557 | 4.1% |
| Other values (11) | 492155 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1540643 | |
| Space Separator | 148619 | 8.2% |
| Uppercase Letter | 126079 | 6.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 269756 | |
| i | 205578 | |
| n | 113918 | 7.4% |
| p | 113918 | 7.4% |
| d | 103539 | 6.7% |
| a | 103539 | 6.7% |
| v | 98102 | 6.4% |
| t | 91660 | 5.9% |
| l | 74557 | 4.8% |
| y | 69120 | 4.5% |
| Other values (7) | 296956 |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 69120 | |
| A | 28982 | |
| S | 27977 |
Space Separator
| Value | Count | Frequency (%) |
| 148619 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1666722 | |
| Common | 148619 | 8.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 269756 | |
| i | 205578 | |
| n | 113918 | 6.8% |
| p | 113918 | 6.8% |
| d | 103539 | 6.2% |
| a | 103539 | 6.2% |
| v | 98102 | 5.9% |
| t | 91660 | 5.5% |
| l | 74557 | 4.5% |
| L | 69120 | 4.1% |
| Other values (10) | 423035 |
Common
| Value | Count | Frequency (%) |
| 148619 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1815341 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 269756 | |
| i | 205578 | |
| 148619 | 8.2% | |
| n | 113918 | 6.3% |
| p | 113918 | 6.3% |
| d | 103539 | 5.7% |
| a | 103539 | 5.7% |
| v | 98102 | 5.4% |
| t | 91660 | 5.0% |
| l | 74557 | 4.1% |
| Other values (11) | 492155 |
Late_delivery_risk
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 126079 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 69120 | |
| 0 | 56959 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 69120 | |
| 0 | 56959 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 69120 | |
| 0 | 56959 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 126079 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 69120 | |
| 0 | 56959 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 126079 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 69120 | |
| 0 | 56959 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 126079 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 69120 | |
| 0 | 56959 |
Category Name
Categorical
HIGH CORRELATION
| Distinct | 38 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| Cleats | |
|---|---|
| Men's Footwear | |
| Women's Apparel | |
| Indoor/Outdoor Games | |
| Water Sports | |
| Other values (33) |
Length
| Max length | 20 |
|---|---|
| Median length | 18 |
| Mean length | 13.027364 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1642477 |
|---|---|
| Distinct characters | 49 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cleats |
|---|---|
| 2nd row | Women's Apparel |
| 3rd row | Shop By Sport |
| 4th row | Women's Apparel |
| 5th row | Women's Apparel |
Common Values
| Value | Count | Frequency (%) |
| Cleats | 21465 | |
| Men's Footwear | 20265 | |
| Women's Apparel | 19114 | |
| Indoor/Outdoor Games | 17483 | |
| Water Sports | 13977 | |
| Shop By Sport | 10169 | |
| Cardio Equipment | 6352 | 5.0% |
| Electronics | 2916 | 2.3% |
| Accessories | 1694 | 1.3% |
| Golf Balls | 1434 | 1.1% |
| Other values (28) | 11210 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| cleats | 21465 | 9.1% |
| men's | 20689 | 8.8% |
| apparel | 20574 | 8.8% |
| footwear | 20265 | 8.6% |
| women's | 19838 | 8.4% |
| games | 18297 | 7.8% |
| indoor/outdoor | 17483 | 7.4% |
| water | 13977 | 6.0% |
| sports | 13977 | 6.0% |
| shop | 10169 | 4.3% |
| Other values (44) | 58138 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 186650 | 11.4% |
| e | 154928 | 9.4% |
| r | 127723 | 7.8% |
| s | 112044 | 6.8% |
| t | 109955 | 6.7% |
| 109696 | 6.7% | |
| a | 106002 | 6.5% |
| p | 82741 | 5.0% |
| n | 71595 | 4.4% |
| l | 57803 | 3.5% |
| Other values (39) | 523340 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1217495 | |
| Uppercase Letter | 253410 | 15.4% |
| Space Separator | 109696 | 6.7% |
| Other Punctuation | 60945 | 3.7% |
| Dash Punctuation | 931 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 186650 | |
| e | 154928 | |
| r | 127723 | |
| s | 112044 | |
| t | 109955 | |
| a | 106002 | |
| p | 82741 | |
| n | 71595 | 5.9% |
| l | 57803 | 4.7% |
| m | 44487 | 3.7% |
| Other values (14) | 163567 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 36329 | |
| W | 33815 | |
| C | 29516 | |
| G | 24149 | |
| A | 22900 | |
| M | 21321 | |
| F | 20549 | |
| I | 18414 | |
| O | 17483 | |
| B | 13152 | 5.2% |
| Other values (9) | 15782 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 41787 | |
| / | 17483 | |
| & | 1643 | 2.7% |
| ! | 32 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 109696 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 931 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1470905 | |
| Common | 171572 | 10.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 186650 | |
| e | 154928 | 10.5% |
| r | 127723 | 8.7% |
| s | 112044 | 7.6% |
| t | 109955 | 7.5% |
| a | 106002 | 7.2% |
| p | 82741 | 5.6% |
| n | 71595 | 4.9% |
| l | 57803 | 3.9% |
| m | 44487 | 3.0% |
| Other values (33) | 416977 |
Common
| Value | Count | Frequency (%) |
| 109696 | ||
| ' | 41787 | 24.4% |
| / | 17483 | 10.2% |
| & | 1643 | 1.0% |
| - | 931 | 0.5% |
| ! | 32 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1642477 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 186650 | 11.4% |
| e | 154928 | 9.4% |
| r | 127723 | 7.8% |
| s | 112044 | 6.8% |
| t | 109955 | 6.7% |
| 109696 | 6.7% | |
| a | 106002 | 6.5% |
| p | 82741 | 5.0% |
| n | 71595 | 4.4% |
| l | 57803 | 3.5% |
| Other values (39) | 523340 |
Customer City
Text
| Distinct | 563 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 19 |
| Mean length | 7.705859 |
| Min length | 2 |
Characters and Unicode
| Total characters | 971547 |
|---|---|
| Distinct characters | 52 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Bayamon |
|---|---|
| 2nd row | Caguas |
| 3rd row | Caguas |
| 4th row | Caguas |
| 5th row | Caguas |
| Value | Count | Frequency (%) |
| caguas | 46699 | |
| san | 3519 | 2.3% |
| chicago | 2741 | 1.8% |
| brooklyn | 2386 | 1.6% |
| los | 2372 | 1.6% |
| angeles | 2372 | 1.6% |
| new | 2183 | 1.4% |
| york | 1518 | 1.0% |
| beach | 1484 | 1.0% |
| city | 1174 | 0.8% |
| Other values (585) | 84968 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 159817 | |
| s | 77961 | 8.0% |
| u | 62497 | 6.4% |
| g | 62299 | 6.4% |
| o | 59675 | 6.1% |
| C | 57770 | 5.9% |
| e | 56510 | 5.8% |
| n | 53103 | 5.5% |
| l | 42585 | 4.4% |
| i | 42215 | 4.3% |
| Other values (42) | 297115 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 794793 | |
| Uppercase Letter | 151417 | 15.6% |
| Space Separator | 25337 | 2.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 159817 | |
| s | 77961 | |
| u | 62497 | 7.9% |
| g | 62299 | 7.8% |
| o | 59675 | 7.5% |
| e | 56510 | 7.1% |
| n | 53103 | 6.7% |
| l | 42585 | 5.4% |
| i | 42215 | 5.3% |
| r | 40055 | 5.0% |
| Other values (16) | 138076 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 57770 | |
| B | 9783 | 6.5% |
| S | 9693 | 6.4% |
| L | 9113 | 6.0% |
| A | 7566 | 5.0% |
| P | 7315 | 4.8% |
| M | 6537 | 4.3% |
| H | 6004 | 4.0% |
| D | 4020 | 2.7% |
| N | 3927 | 2.6% |
| Other values (15) | 29689 |
Space Separator
| Value | Count | Frequency (%) |
| 25337 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 946210 | |
| Common | 25337 | 2.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 159817 | |
| s | 77961 | 8.2% |
| u | 62497 | 6.6% |
| g | 62299 | 6.6% |
| o | 59675 | 6.3% |
| C | 57770 | 6.1% |
| e | 56510 | 6.0% |
| n | 53103 | 5.6% |
| l | 42585 | 4.5% |
| i | 42215 | 4.5% |
| Other values (41) | 271778 |
Common
| Value | Count | Frequency (%) |
| 25337 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 971547 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 159817 | |
| s | 77961 | 8.0% |
| u | 62497 | 6.4% |
| g | 62299 | 6.4% |
| o | 59675 | 6.1% |
| C | 57770 | 5.9% |
| e | 56510 | 5.8% |
| n | 53103 | 5.5% |
| l | 42585 | 4.4% |
| i | 42215 | 4.3% |
| Other values (42) | 297115 |
Customer Country
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| EE. UU. | |
|---|---|
| Puerto Rico |
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 8.5382419 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1076493 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Puerto Rico |
|---|---|
| 2nd row | Puerto Rico |
| 3rd row | Puerto Rico |
| 4th row | Puerto Rico |
| 5th row | Puerto Rico |
Common Values
| Value | Count | Frequency (%) |
| EE. UU. | 77594 | |
| Puerto Rico | 48485 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ee | 77594 | |
| uu | 77594 | |
| puerto | 48485 | |
| rico | 48485 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 155188 | |
| . | 155188 | |
| U | 155188 | |
| 126079 | ||
| o | 96970 | |
| P | 48485 | 4.5% |
| u | 48485 | 4.5% |
| e | 48485 | 4.5% |
| r | 48485 | 4.5% |
| t | 48485 | 4.5% |
| Other values (3) | 145455 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 407346 | |
| Lowercase Letter | 387880 | |
| Other Punctuation | 155188 | 14.4% |
| Space Separator | 126079 | 11.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 96970 | |
| u | 48485 | |
| e | 48485 | |
| r | 48485 | |
| t | 48485 | |
| i | 48485 | |
| c | 48485 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 155188 | |
| U | 155188 | |
| P | 48485 | 11.9% |
| R | 48485 | 11.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 155188 |
Space Separator
| Value | Count | Frequency (%) |
| 126079 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 795226 | |
| Common | 281267 | 26.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 155188 | |
| U | 155188 | |
| o | 96970 | |
| P | 48485 | 6.1% |
| u | 48485 | 6.1% |
| e | 48485 | 6.1% |
| r | 48485 | 6.1% |
| t | 48485 | 6.1% |
| R | 48485 | 6.1% |
| i | 48485 | 6.1% |
Common
| Value | Count | Frequency (%) |
| . | 155188 | |
| 126079 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1076493 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 155188 | |
| . | 155188 | |
| U | 155188 | |
| 126079 | ||
| o | 96970 | |
| P | 48485 | 4.5% |
| u | 48485 | 4.5% |
| e | 48485 | 4.5% |
| r | 48485 | 4.5% |
| t | 48485 | 4.5% |
| Other values (3) | 145455 |
Customer Id
Real number (ℝ)
HIGH CORRELATION
| Distinct | 16158 |
|---|---|
| Distinct (%) | 12.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6557.3053 |
| Minimum | 2 |
|---|---|
| Maximum | 20757 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 640 |
| Q1 | 3208 |
| median | 6352 |
| Q3 | 9633 |
| 95-th percentile | 12188 |
| Maximum | 20757 |
| Range | 20755 |
| Interquartile range (IQR) | 6425 |
Descriptive statistics
| Standard deviation | 4059.5834 |
|---|---|
| Coefficient of variation (CV) | 0.61909324 |
| Kurtosis | 0.15956483 |
| Mean | 6557.3053 |
| Median Absolute Deviation (MAD) | 3208 |
| Skewness | 0.49465161 |
| Sum | 8.267385 × 108 |
| Variance | 16480217 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5004 | 37 | < 0.1% |
| 10591 | 36 | < 0.1% |
| 12284 | 35 | < 0.1% |
| 11048 | 34 | < 0.1% |
| 5654 | 33 | < 0.1% |
| 2970 | 33 | < 0.1% |
| 5648 | 32 | < 0.1% |
| 1588 | 32 | < 0.1% |
| 3708 | 32 | < 0.1% |
| 8015 | 32 | < 0.1% |
| Other values (16148) | 125743 |
| Value | Count | Frequency (%) |
| 2 | 7 | |
| 3 | 12 | |
| 4 | 11 | |
| 5 | 6 | < 0.1% |
| 6 | 11 | |
| 7 | 13 | |
| 8 | 15 | |
| 9 | 7 | |
| 10 | 7 | |
| 11 | 11 |
| Value | Count | Frequency (%) |
| 20757 | 1 | |
| 20756 | 1 | |
| 20752 | 1 | |
| 20751 | 1 | |
| 20750 | 1 | |
| 20749 | 1 | |
| 20748 | 1 | |
| 20747 | 1 | |
| 20746 | 1 | |
| 20744 | 1 |
Customer Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.8394816 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1114473 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Home Office |
|---|---|
| 2nd row | Home Office |
| 3rd row | Home Office |
| 4th row | Home Office |
| 5th row | Home Office |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 65316 | |
| Corporate | 38224 | |
| Home Office | 22539 | 17.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 65316 | |
| corporate | 38224 | |
| home | 22539 | 15.2% |
| office | 22539 | 15.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 164303 | |
| e | 148618 | |
| r | 141764 | |
| C | 103540 | |
| m | 87855 | |
| n | 65316 | 5.9% |
| s | 65316 | 5.9% |
| u | 65316 | 5.9% |
| f | 45078 | 4.0% |
| t | 38224 | 3.4% |
| Other values (7) | 189143 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 943316 | |
| Uppercase Letter | 148618 | 13.3% |
| Space Separator | 22539 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 164303 | |
| e | 148618 | |
| r | 141764 | |
| m | 87855 | |
| n | 65316 | 6.9% |
| s | 65316 | 6.9% |
| u | 65316 | 6.9% |
| f | 45078 | 4.8% |
| t | 38224 | 4.1% |
| p | 38224 | 4.1% |
| Other values (3) | 83302 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 103540 | |
| H | 22539 | 15.2% |
| O | 22539 | 15.2% |
Space Separator
| Value | Count | Frequency (%) |
| 22539 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1091934 | |
| Common | 22539 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 164303 | |
| e | 148618 | |
| r | 141764 | |
| C | 103540 | |
| m | 87855 | |
| n | 65316 | 6.0% |
| s | 65316 | 6.0% |
| u | 65316 | 6.0% |
| f | 45078 | 4.1% |
| t | 38224 | 3.5% |
| Other values (6) | 166604 |
Common
| Value | Count | Frequency (%) |
| 22539 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1114473 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 164303 | |
| e | 148618 | |
| r | 141764 | |
| C | 103540 | |
| m | 87855 | |
| n | 65316 | 5.9% |
| s | 65316 | 5.9% |
| u | 65316 | 5.9% |
| f | 45078 | 4.0% |
| t | 38224 | 3.4% |
| Other values (7) | 189143 |
Customer State
Categorical
HIGH CORRELATION
| Distinct | 45 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| PR | |
|---|---|
| CA | |
| NY | |
| TX | |
| IL | |
| Other values (40) |
Length
| Max length | 5 |
|---|---|
| Median length | 2 |
| Mean length | 2.0000238 |
| Min length | 2 |
Characters and Unicode
| Total characters | 252161 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PR |
|---|---|
| 2nd row | PR |
| 3rd row | PR |
| 4th row | PR |
| 5th row | PR |
Common Values
| Value | Count | Frequency (%) |
| PR | 48485 | |
| CA | 20403 | |
| NY | 7931 | 6.3% |
| TX | 6350 | 5.0% |
| IL | 5358 | 4.2% |
| FL | 3841 | 3.0% |
| OH | 2850 | 2.3% |
| PA | 2702 | 2.1% |
| MI | 2617 | 2.1% |
| NJ | 2167 | 1.7% |
| Other values (35) | 23375 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| pr | 48485 | |
| ca | 20403 | |
| ny | 7931 | 6.3% |
| tx | 6350 | 5.0% |
| il | 5358 | 4.2% |
| fl | 3841 | 3.0% |
| oh | 2850 | 2.3% |
| pa | 2702 | 2.1% |
| mi | 2617 | 2.1% |
| nj | 2167 | 1.7% |
| Other values (35) | 23375 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 51187 | |
| R | 49931 | |
| A | 30865 | |
| C | 24794 | |
| N | 15267 | 6.1% |
| I | 10157 | 4.0% |
| L | 9868 | 3.9% |
| T | 8947 | 3.5% |
| Y | 8279 | 3.3% |
| M | 7563 | 3.0% |
| Other values (18) | 35303 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 252156 | |
| Decimal Number | 5 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 51187 | |
| R | 49931 | |
| A | 30865 | |
| C | 24794 | |
| N | 15267 | 6.1% |
| I | 10157 | 4.0% |
| L | 9868 | 3.9% |
| T | 8947 | 3.5% |
| Y | 8279 | 3.3% |
| M | 7563 | 3.0% |
| Other values (14) | 35298 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 2 | |
| 9 | 1 | |
| 7 | 1 | |
| 8 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 252156 | |
| Common | 5 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 51187 | |
| R | 49931 | |
| A | 30865 | |
| C | 24794 | |
| N | 15267 | 6.1% |
| I | 10157 | 4.0% |
| L | 9868 | 3.9% |
| T | 8947 | 3.5% |
| Y | 8279 | 3.3% |
| M | 7563 | 3.0% |
| Other values (14) | 35298 |
Common
| Value | Count | Frequency (%) |
| 5 | 2 | |
| 9 | 1 | |
| 7 | 1 | |
| 8 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 252161 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 51187 | |
| R | 49931 | |
| A | 30865 | |
| C | 24794 | |
| N | 15267 | 6.1% |
| I | 10157 | 4.0% |
| L | 9868 | 3.9% |
| T | 8947 | 3.5% |
| Y | 8279 | 3.3% |
| M | 7563 | 3.0% |
| Other values (18) | 35303 |
Department Name
Categorical
HIGH CORRELATION
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| Apparel | |
|---|---|
| Fan Shop | |
| Golf | |
| Outdoors | |
| Footwear | |
| Other values (4) | 4236 |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 6.7117284 |
| Min length | 4 |
Characters and Unicode
| Total characters | 846208 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Apparel |
|---|---|
| 2nd row | Golf |
| 3rd row | Golf |
| 4th row | Golf |
| 5th row | Golf |
Common Values
| Value | Count | Frequency (%) |
| Apparel | 42712 | |
| Fan Shop | 32371 | |
| Golf | 30322 | |
| Outdoors | 8343 | 6.6% |
| Footwear | 8095 | 6.4% |
| Fitness | 1857 | 1.5% |
| Discs Shop | 1517 | 1.2% |
| Pet Shop | 463 | 0.4% |
| Book Shop | 399 | 0.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| apparel | 42712 | |
| shop | 34750 | |
| fan | 32371 | |
| golf | 30322 | |
| outdoors | 8343 | 5.2% |
| footwear | 8095 | 5.0% |
| fitness | 1857 | 1.2% |
| discs | 1517 | 0.9% |
| pet | 463 | 0.3% |
| book | 399 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 120174 | |
| o | 98746 | |
| a | 83178 | |
| l | 73034 | 8.6% |
| r | 59150 | 7.0% |
| e | 53127 | 6.3% |
| A | 42712 | 5.0% |
| F | 42323 | 5.0% |
| 34750 | 4.1% | |
| S | 34750 | 4.1% |
| Other values (16) | 204264 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 650629 | |
| Uppercase Letter | 160829 | 19.0% |
| Space Separator | 34750 | 4.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| p | 120174 | |
| o | 98746 | |
| a | 83178 | |
| l | 73034 | |
| r | 59150 | |
| e | 53127 | |
| h | 34750 | 5.3% |
| n | 34228 | 5.3% |
| f | 30322 | 4.7% |
| t | 18758 | 2.9% |
| Other values (7) | 45162 | 6.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 42712 | |
| F | 42323 | |
| S | 34750 | |
| G | 30322 | |
| O | 8343 | 5.2% |
| D | 1517 | 0.9% |
| P | 463 | 0.3% |
| B | 399 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 34750 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 811458 | |
| Common | 34750 | 4.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| p | 120174 | |
| o | 98746 | |
| a | 83178 | |
| l | 73034 | |
| r | 59150 | 7.3% |
| e | 53127 | 6.5% |
| A | 42712 | 5.3% |
| F | 42323 | 5.2% |
| S | 34750 | 4.3% |
| h | 34750 | 4.3% |
| Other values (15) | 169514 |
Common
| Value | Count | Frequency (%) |
| 34750 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 846208 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| p | 120174 | |
| o | 98746 | |
| a | 83178 | |
| l | 73034 | 8.6% |
| r | 59150 | 7.0% |
| e | 53127 | 6.3% |
| A | 42712 | 5.0% |
| F | 42323 | 5.0% |
| 34750 | 4.1% | |
| S | 34750 | 4.1% |
| Other values (16) | 204264 |
Market
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| LATAM | |
|---|---|
| Europe | |
| Pacific Asia | |
| USCA | |
| Africa |
Length
| Max length | 12 |
|---|---|
| Median length | 6 |
| Mean length | 6.775482 |
| Min length | 4 |
Characters and Unicode
| Total characters | 854246 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Pacific Asia |
|---|---|
| 2nd row | Pacific Asia |
| 3rd row | Pacific Asia |
| 4th row | Pacific Asia |
| 5th row | Pacific Asia |
Common Values
| Value | Count | Frequency (%) |
| LATAM | 36698 | |
| Europe | 34053 | |
| Pacific Asia | 28561 | |
| USCA | 18448 | |
| Africa | 8319 | 6.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| latam | 36698 | |
| europe | 34053 | |
| pacific | 28561 | |
| asia | 28561 | |
| usca | 18448 | |
| africa | 8319 | 5.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 128724 | |
| i | 94002 | 11.0% |
| a | 65441 | 7.7% |
| c | 65441 | 7.7% |
| r | 42372 | 5.0% |
| f | 36880 | 4.3% |
| L | 36698 | 4.3% |
| T | 36698 | 4.3% |
| M | 36698 | 4.3% |
| E | 34053 | 4.0% |
| Other values (10) | 277239 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 468909 | |
| Uppercase Letter | 356776 | |
| Space Separator | 28561 | 3.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 94002 | |
| a | 65441 | |
| c | 65441 | |
| r | 42372 | |
| f | 36880 | 7.9% |
| u | 34053 | 7.3% |
| o | 34053 | 7.3% |
| p | 34053 | 7.3% |
| e | 34053 | 7.3% |
| s | 28561 | 6.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 128724 | |
| L | 36698 | 10.3% |
| T | 36698 | 10.3% |
| M | 36698 | 10.3% |
| E | 34053 | 9.5% |
| P | 28561 | 8.0% |
| U | 18448 | 5.2% |
| S | 18448 | 5.2% |
| C | 18448 | 5.2% |
Space Separator
| Value | Count | Frequency (%) |
| 28561 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 825685 | |
| Common | 28561 | 3.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 128724 | |
| i | 94002 | 11.4% |
| a | 65441 | 7.9% |
| c | 65441 | 7.9% |
| r | 42372 | 5.1% |
| f | 36880 | 4.5% |
| L | 36698 | 4.4% |
| T | 36698 | 4.4% |
| M | 36698 | 4.4% |
| E | 34053 | 4.1% |
| Other values (9) | 248678 |
Common
| Value | Count | Frequency (%) |
| 28561 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 854246 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 128724 | |
| i | 94002 | 11.0% |
| a | 65441 | 7.7% |
| c | 65441 | 7.7% |
| r | 42372 | 5.0% |
| f | 36880 | 4.3% |
| L | 36698 | 4.3% |
| T | 36698 | 4.3% |
| M | 36698 | 4.3% |
| E | 34053 | 4.0% |
| Other values (10) | 277239 |
Order City
Text
| Distinct | 3566 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 35 |
|---|---|
| Median length | 29 |
| Mean length | 8.5641066 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1079754 |
|---|---|
| Distinct characters | 77 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 122 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Mirzapur |
|---|---|
| 2nd row | Murray Bridge |
| 3rd row | Kartal |
| 4th row | Ulan Bator |
| 5th row | Estambul |
| Value | Count | Frequency (%) |
| san | 4614 | 2.9% |
| city | 3943 | 2.5% |
| de | 2288 | 1.4% |
| santo | 1720 | 1.1% |
| los | 1718 | 1.1% |
| domingo | 1647 | 1.0% |
| new | 1628 | 1.0% |
| york | 1625 | 1.0% |
| angeles | 1304 | 0.8% |
| tegucigalpa | 1254 | 0.8% |
| Other values (3736) | 137828 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 138925 | 12.9% |
| e | 81275 | 7.5% |
| n | 80197 | 7.4% |
| o | 77851 | 7.2% |
| i | 66005 | 6.1% |
| r | 59661 | 5.5% |
| l | 53670 | 5.0% |
| u | 40386 | 3.7% |
| t | 39440 | 3.7% |
| s | 39099 | 3.6% |
| Other values (67) | 403245 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 883770 | |
| Uppercase Letter | 157908 | 14.6% |
| Space Separator | 33490 | 3.1% |
| Dash Punctuation | 4098 | 0.4% |
| Other Punctuation | 453 | < 0.1% |
| Close Punctuation | 15 | < 0.1% |
| Open Punctuation | 15 | < 0.1% |
| Final Punctuation | 5 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 138925 | |
| e | 81275 | 9.2% |
| n | 80197 | 9.1% |
| o | 77851 | 8.8% |
| i | 66005 | 7.5% |
| r | 59661 | 6.8% |
| l | 53670 | 6.1% |
| u | 40386 | 4.6% |
| t | 39440 | 4.5% |
| s | 39099 | 4.4% |
| Other values (30) | 207261 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 19722 | |
| C | 17941 | |
| M | 16408 | 10.4% |
| B | 11586 | 7.3% |
| P | 10668 | 6.8% |
| L | 10341 | 6.5% |
| A | 9455 | 6.0% |
| T | 7160 | 4.5% |
| D | 6321 | 4.0% |
| N | 5555 | 3.5% |
| Other values (19) | 42751 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 338 | |
| ? | 103 | 22.7% |
| . | 12 | 2.6% |
Space Separator
| Value | Count | Frequency (%) |
| 33490 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4098 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 15 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 15 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1041678 | |
| Common | 38076 | 3.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 138925 | 13.3% |
| e | 81275 | 7.8% |
| n | 80197 | 7.7% |
| o | 77851 | 7.5% |
| i | 66005 | 6.3% |
| r | 59661 | 5.7% |
| l | 53670 | 5.2% |
| u | 40386 | 3.9% |
| t | 39440 | 3.8% |
| s | 39099 | 3.8% |
| Other values (59) | 365169 |
Common
| Value | Count | Frequency (%) |
| 33490 | ||
| - | 4098 | 10.8% |
| ' | 338 | 0.9% |
| ? | 103 | 0.3% |
| ) | 15 | < 0.1% |
| ( | 15 | < 0.1% |
| . | 12 | < 0.1% |
| ’ | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1068688 | |
| None | 11061 | 1.0% |
| Punctuation | 5 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 138925 | 13.0% |
| e | 81275 | 7.6% |
| n | 80197 | 7.5% |
| o | 77851 | 7.3% |
| i | 66005 | 6.2% |
| r | 59661 | 5.6% |
| l | 53670 | 5.0% |
| u | 40386 | 3.8% |
| t | 39440 | 3.7% |
| s | 39099 | 3.7% |
| Other values (49) | 392179 |
None
| Value | Count | Frequency (%) |
| á | 2986 | |
| í | 2913 | |
| ó | 1568 | |
| é | 1038 | 9.4% |
| ã | 957 | 8.7% |
| ú | 806 | 7.3% |
| ç | 216 | 2.0% |
| ü | 184 | 1.7% |
| ñ | 125 | 1.1% |
| Á | 104 | 0.9% |
| Other values (7) | 164 | 1.5% |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 5 |
Order Country
Text
| Distinct | 164 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 31 |
|---|---|
| Median length | 22 |
| Mean length | 8.7930663 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1108621 |
|---|---|
| Distinct characters | 61 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | India |
|---|---|
| 2nd row | Australia |
| 3rd row | Turquía |
| 4th row | Mongolia |
| 5th row | Turquía |
| Value | Count | Frequency (%) |
| unidos | 17773 | 11.0% |
| estados | 17751 | 11.0% |
| méxico | 9398 | 5.8% |
| francia | 8954 | 5.6% |
| alemania | 6409 | 4.0% |
| australia | 5860 | 3.6% |
| brasil | 5674 | 3.5% |
| reino | 4896 | 3.0% |
| unido | 4896 | 3.0% |
| china | 3939 | 2.4% |
| Other values (175) | 75696 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 168375 | |
| i | 115881 | 10.5% |
| s | 83352 | 7.5% |
| n | 83164 | 7.5% |
| o | 77373 | 7.0% |
| d | 58751 | 5.3% |
| r | 46568 | 4.2% |
| l | 43158 | 3.9% |
| e | 36939 | 3.3% |
| t | 35702 | 3.2% |
| Other values (51) | 359358 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 912265 | |
| Uppercase Letter | 160631 | 14.5% |
| Space Separator | 35167 | 3.2% |
| Open Punctuation | 270 | < 0.1% |
| Close Punctuation | 270 | < 0.1% |
| Dash Punctuation | 18 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 168375 | |
| i | 115881 | |
| s | 83352 | |
| n | 83164 | |
| o | 77373 | |
| d | 58751 | 6.4% |
| r | 46568 | 5.1% |
| l | 43158 | 4.7% |
| e | 36939 | 4.0% |
| t | 35702 | 3.9% |
| Other values (22) | 163002 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 24111 | |
| U | 23624 | |
| A | 16814 | |
| I | 11789 | |
| M | 11633 | |
| C | 10739 | 6.7% |
| F | 10592 | 6.6% |
| R | 9547 | 5.9% |
| B | 8638 | 5.4% |
| S | 6109 | 3.8% |
| Other values (15) | 27035 |
Space Separator
| Value | Count | Frequency (%) |
| 35167 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 270 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 270 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 18 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1072896 | |
| Common | 35725 | 3.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 168375 | |
| i | 115881 | 10.8% |
| s | 83352 | 7.8% |
| n | 83164 | 7.8% |
| o | 77373 | 7.2% |
| d | 58751 | 5.5% |
| r | 46568 | 4.3% |
| l | 43158 | 4.0% |
| e | 36939 | 3.4% |
| t | 35702 | 3.3% |
| Other values (47) | 323633 |
Common
| Value | Count | Frequency (%) |
| 35167 | ||
| ( | 270 | 0.8% |
| ) | 270 | 0.8% |
| - | 18 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1081458 | |
| None | 27163 | 2.5% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 168375 | |
| i | 115881 | 10.7% |
| s | 83352 | 7.7% |
| n | 83164 | 7.7% |
| o | 77373 | 7.2% |
| d | 58751 | 5.4% |
| r | 46568 | 4.3% |
| l | 43158 | 4.0% |
| e | 36939 | 3.4% |
| t | 35702 | 3.3% |
| Other values (44) | 332195 |
None
| Value | Count | Frequency (%) |
| é | 10155 | |
| í | 5054 | |
| á | 4418 | |
| ú | 4351 | |
| ñ | 2612 | 9.6% |
| ó | 551 | 2.0% |
| Á | 22 | 0.1% |
Order Item Discount
Real number (ℝ)
ZEROS
| Distinct | 767 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.781839 |
| Minimum | 0 |
|---|---|
| Maximum | 60 |
| Zeros | 6978 |
| Zeros (%) | 5.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4.4000001 |
| median | 10.8 |
| Q3 | 22.49 |
| 95-th percentile | 40 |
| Maximum | 60 |
| Range | 60 |
| Interquartile range (IQR) | 18.09 |
Descriptive statistics
| Standard deviation | 13.042924 |
|---|---|
| Coefficient of variation (CV) | 0.88236136 |
| Kurtosis | 0.5487285 |
| Mean | 14.781839 |
| Median Absolute Deviation (MAD) | 8.0200002 |
| Skewness | 1.0635925 |
| Sum | 1863679.5 |
| Variance | 170.11786 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 6978 | 5.5% |
| 6 | 3412 | 2.7% |
| 10 | 2993 | 2.4% |
| 2 | 2632 | 2.1% |
| 18 | 2451 | 1.9% |
| 4 | 2324 | 1.8% |
| 8 | 2315 | 1.8% |
| 26 | 2248 | 1.8% |
| 30 | 2111 | 1.7% |
| 9 | 1955 | 1.6% |
| Other values (757) | 96660 |
| Value | Count | Frequency (%) |
| 0 | 6978 | |
| 0.100000001 | 3 | < 0.1% |
| 0.109999999 | 15 | < 0.1% |
| 0.119999997 | 29 | < 0.1% |
| 0.150000006 | 7 | < 0.1% |
| 0.159999996 | 7 | < 0.1% |
| 0.180000007 | 3 | < 0.1% |
| 0.200000003 | 16 | < 0.1% |
| 0.219999999 | 6 | < 0.1% |
| 0.230000004 | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 60 | 2 | < 0.1% |
| 59.99000168 | 638 | |
| 59.97000122 | 1 | < 0.1% |
| 59.40000153 | 1 | < 0.1% |
| 58.5 | 3 | < 0.1% |
| 57.59999847 | 1 | < 0.1% |
| 56.99000168 | 1 | < 0.1% |
| 56.24000168 | 6 | < 0.1% |
| 56 | 3 | < 0.1% |
| 55.25 | 3 | < 0.1% |
Order Item Product Price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 57 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83.329405 |
| Minimum | 9.9899998 |
|---|---|
| Maximum | 249.99001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 9.9899998 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 49.98 |
| median | 59.990002 |
| Q3 | 129.99001 |
| 95-th percentile | 199.99001 |
| Maximum | 249.99001 |
| Range | 240.00001 |
| Interquartile range (IQR) | 80.010006 |
Descriptive statistics
| Standard deviation | 54.526666 |
|---|---|
| Coefficient of variation (CV) | 0.65435084 |
| Kurtosis | -0.019828239 |
| Mean | 83.329405 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 1.1008913 |
| Sum | 10506088 |
| Variance | 2973.1573 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 59.99000168 | 21733 | |
| 129.9900055 | 20385 | |
| 50 | 19114 | |
| 49.97999954 | 17483 | |
| 199.9900055 | 14084 | |
| 39.99000168 | 10366 | |
| 99.98999786 | 6186 | 4.9% |
| 24.98999977 | 2231 | 1.8% |
| 31.98999977 | 1373 | 1.1% |
| 30 | 861 | 0.7% |
| Other values (47) | 12263 |
| Value | Count | Frequency (%) |
| 9.989999771 | 280 | 0.2% |
| 11.28999996 | 271 | 0.2% |
| 11.53999996 | 529 | 0.4% |
| 14.98999977 | 576 | 0.5% |
| 15.98999977 | 583 | 0.5% |
| 17.98999977 | 293 | 0.2% |
| 19.98999977 | 859 | 0.7% |
| 21.98999977 | 283 | 0.2% |
| 22 | 297 | 0.2% |
| 24.98999977 | 2231 |
| Value | Count | Frequency (%) |
| 249.9900055 | 110 | 0.1% |
| 215.8200073 | 598 | 0.5% |
| 210.8500061 | 183 | 0.1% |
| 209.9900055 | 56 | < 0.1% |
| 199.9900055 | 14084 | |
| 199 | 61 | < 0.1% |
| 189 | 57 | < 0.1% |
| 179.9900055 | 57 | < 0.1% |
| 169.9900055 | 59 | < 0.1% |
| 164.3800049 | 432 | 0.3% |
Order Item Quantity
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| 1 | |
|---|---|
| 2 | |
| 3 | |
| 4 | |
| 5 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 126079 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 58993 | |
| 2 | 18819 | 14.9% |
| 3 | 17969 | 14.3% |
| 4 | 16019 | 12.7% |
| 5 | 14279 | 11.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 58993 | |
| 2 | 18819 | 14.9% |
| 3 | 17969 | 14.3% |
| 4 | 16019 | 12.7% |
| 5 | 14279 | 11.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 58993 | |
| 2 | 18819 | 14.9% |
| 3 | 17969 | 14.3% |
| 4 | 16019 | 12.7% |
| 5 | 14279 | 11.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 126079 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 58993 | |
| 2 | 18819 | 14.9% |
| 3 | 17969 | 14.3% |
| 4 | 16019 | 12.7% |
| 5 | 14279 | 11.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 126079 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 58993 | |
| 2 | 18819 | 14.9% |
| 3 | 17969 | 14.3% |
| 4 | 16019 | 12.7% |
| 5 | 14279 | 11.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 126079 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 58993 | |
| 2 | 18819 | 14.9% |
| 3 | 17969 | 14.3% |
| 4 | 16019 | 12.7% |
| 5 | 14279 | 11.3% |
Sales
Real number (ℝ)
HIGH CORRELATION
| Distinct | 161 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 147.18932 |
| Minimum | 9.9899998 |
|---|---|
| Maximum | 325 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 9.9899998 |
|---|---|
| 5-th percentile | 39.990002 |
| Q1 | 99.989998 |
| median | 129.99001 |
| Q3 | 199.99001 |
| 95-th percentile | 250 |
| Maximum | 325 |
| Range | 315.01 |
| Interquartile range (IQR) | 100.00001 |
Descriptive statistics
| Standard deviation | 69.237358 |
|---|---|
| Coefficient of variation (CV) | 0.47039662 |
| Kurtosis | -0.62058731 |
| Mean | 147.18932 |
| Median Absolute Deviation (MAD) | 69.929993 |
| Skewness | 0.19810168 |
| Sum | 18557482 |
| Variance | 4793.8117 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 129.9900055 | 20385 | 16.2% |
| 199.9900055 | 14084 | 11.2% |
| 59.99000168 | 4736 | 3.8% |
| 179.9700012 | 4578 | 3.6% |
| 119.9800034 | 4552 | 3.6% |
| 239.9600067 | 4455 | 3.5% |
| 50 | 4286 | 3.4% |
| 49.97999954 | 4196 | 3.3% |
| 99.95999908 | 4028 | 3.2% |
| 100 | 3965 | 3.1% |
| Other values (151) | 56814 |
| Value | Count | Frequency (%) |
| 9.989999771 | 56 | < 0.1% |
| 11.28999996 | 271 | |
| 11.53999996 | 529 | |
| 14.98999977 | 124 | 0.1% |
| 15.98999977 | 118 | 0.1% |
| 17.98999977 | 62 | < 0.1% |
| 19.97999954 | 54 | < 0.1% |
| 19.98999977 | 176 | 0.1% |
| 21.98999977 | 51 | < 0.1% |
| 22 | 64 | 0.1% |
| Value | Count | Frequency (%) |
| 325 | 33 | < 0.1% |
| 320 | 9 | < 0.1% |
| 319.9599915 | 24 | < 0.1% |
| 300 | 10 | < 0.1% |
| 299.9700012 | 1704 | |
| 299.9500122 | 3412 | |
| 299.8500061 | 10 | < 0.1% |
| 297 | 9 | < 0.1% |
| 284.9700012 | 9 | < 0.1% |
| 280 | 43 | < 0.1% |
Order Item Total
Real number (ℝ)
HIGH CORRELATION
| Distinct | 2391 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 132.40764 |
| Minimum | 7.4899998 |
|---|---|
| Maximum | 318.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 7.4899998 |
|---|---|
| 5-th percentile | 37.790001 |
| Q1 | 88 |
| median | 124.79 |
| Q3 | 179.98 |
| 95-th percentile | 242.5 |
| Maximum | 318.5 |
| Range | 311.01 |
| Interquartile range (IQR) | 91.979996 |
Descriptive statistics
| Standard deviation | 63.465626 |
|---|---|
| Coefficient of variation (CV) | 0.47931997 |
| Kurtosis | -0.52885893 |
| Mean | 132.40764 |
| Median Absolute Deviation (MAD) | 46.18 |
| Skewness | 0.26566341 |
| Sum | 16693823 |
| Variance | 4027.8857 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 116.9899979 | 1147 | 0.9% |
| 109.1900024 | 1143 | 0.9% |
| 107.8899994 | 1143 | 0.9% |
| 120.8899994 | 1141 | 0.9% |
| 97.48999786 | 1141 | 0.9% |
| 113.0899963 | 1139 | 0.9% |
| 123.4899979 | 1139 | 0.9% |
| 127.3899994 | 1136 | 0.9% |
| 106.5899963 | 1135 | 0.9% |
| 118.2900009 | 1133 | 0.9% |
| Other values (2381) | 114682 |
| Value | Count | Frequency (%) |
| 7.489999771 | 3 | < 0.1% |
| 7.989999771 | 3 | < 0.1% |
| 8.18999958 | 3 | < 0.1% |
| 8.289999962 | 3 | < 0.1% |
| 8.390000343 | 3 | < 0.1% |
| 8.470000267 | 15 | |
| 8.489999771 | 3 | < 0.1% |
| 8.659999847 | 29 | |
| 8.68999958 | 3 | < 0.1% |
| 8.789999962 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 318.5 | 2 | |
| 316.7600098 | 1 | < 0.1% |
| 315.25 | 3 | |
| 313.6000061 | 1 | < 0.1% |
| 313.5599976 | 1 | < 0.1% |
| 312 | 2 | |
| 310.3599854 | 1 | < 0.1% |
| 308.75 | 2 | |
| 307.2000122 | 1 | < 0.1% |
| 307.1600037 | 3 |
Order Profit Per Order
Real number (ℝ)
HIGH CORRELATION
| Distinct | 11882 |
|---|---|
| Distinct (%) | 9.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.608891 |
| Minimum | -56.060001 |
|---|---|
| Maximum | 119.51 |
| Zeros | 916 |
| Zeros (%) | 0.7% |
| Negative | 14591 |
| Negative (%) | 11.6% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | -56.060001 |
|---|---|
| 5-th percentile | -22.981 |
| Q1 | 10.56 |
| median | 29.120001 |
| Q3 | 53.150002 |
| 95-th percentile | 88.190002 |
| Maximum | 119.51 |
| Range | 175.57 |
| Interquartile range (IQR) | 42.590001 |
Descriptive statistics
| Standard deviation | 32.194877 |
|---|---|
| Coefficient of variation (CV) | 1.0185387 |
| Kurtosis | -0.03514385 |
| Mean | 31.608891 |
| Median Absolute Deviation (MAD) | 20.720001 |
| Skewness | 0.10426268 |
| Sum | 3985217.4 |
| Variance | 1036.5101 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 916 | 0.7% |
| 46.79999924 | 180 | 0.1% |
| 63.70000076 | 169 | 0.1% |
| 38.22000122 | 147 | 0.1% |
| 14.39999962 | 146 | 0.1% |
| 12 | 146 | 0.1% |
| 18 | 145 | 0.1% |
| 72 | 143 | 0.1% |
| 62.40000153 | 137 | 0.1% |
| 43.68000031 | 137 | 0.1% |
| Other values (11872) | 123813 |
| Value | Count | Frequency (%) |
| -56.06000137 | 1 | < 0.1% |
| -56.02000046 | 8 | |
| -56 | 1 | < 0.1% |
| -55.99000168 | 2 | < 0.1% |
| -55.97999954 | 1 | < 0.1% |
| -55.97000122 | 1 | < 0.1% |
| -55.95999908 | 1 | < 0.1% |
| -55.93999863 | 1 | < 0.1% |
| -55.91999817 | 1 | < 0.1% |
| -55.90999985 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 119.5100021 | 9 | |
| 119.5 | 17 | |
| 119.2900009 | 1 | < 0.1% |
| 119.0599976 | 2 | < 0.1% |
| 119.0500031 | 1 | < 0.1% |
| 118.8300018 | 8 | |
| 118.8199997 | 2 | < 0.1% |
| 118.8000031 | 18 | |
| 118.7900009 | 4 | < 0.1% |
| 118.7799988 | 12 |
Order Region
Categorical
HIGH CORRELATION
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| Central America | |
|---|---|
| Western Europe | |
| South America | |
| Oceania | |
| Northern Europe | |
| Other values (18) |
Length
| Max length | 15 |
|---|---|
| Median length | 14 |
| Mean length | 12.617042 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1590744 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South Asia |
|---|---|
| 2nd row | Oceania |
| 3rd row | West Asia |
| 4th row | Eastern Asia |
| 5th row | West Asia |
Common Values
| Value | Count | Frequency (%) |
| Central America | 20092 | |
| Western Europe | 18317 | |
| South America | 10672 | 8.5% |
| Oceania | 7016 | 5.6% |
| Northern Europe | 6552 | 5.2% |
| Southeast Asia | 6527 | 5.2% |
| Southern Europe | 6405 | 5.1% |
| Caribbean | 5934 | 4.7% |
| West of USA | 5715 | 4.5% |
| South Asia | 5311 | 4.2% |
| Other values (13) | 33538 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| europe | 34053 | |
| america | 30764 | |
| central | 21670 | 8.6% |
| asia | 21545 | 8.5% |
| south | 18903 | 7.5% |
| western | 18317 | 7.3% |
| of | 13540 | 5.4% |
| usa | 13540 | 5.4% |
| west | 12682 | 5.0% |
| africa | 8319 | 3.3% |
| Other values (11) | 58718 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 185242 | 11.6% |
| r | 153725 | 9.7% |
| 141738 | 8.9% | |
| a | 130783 | 8.2% |
| t | 118959 | 7.5% |
| o | 89178 | 5.6% |
| n | 79385 | 5.0% |
| A | 74168 | 4.7% |
| i | 73578 | 4.6% |
| s | 73038 | 4.6% |
| Other values (16) | 470950 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1179204 | |
| Uppercase Letter | 269802 | 17.0% |
| Space Separator | 141738 | 8.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 185242 | |
| r | 153725 | |
| a | 130783 | |
| t | 118959 | |
| o | 89178 | |
| n | 79385 | |
| i | 73578 | 6.2% |
| s | 73038 | 6.2% |
| u | 66721 | 5.7% |
| c | 46099 | 3.9% |
| Other values (7) | 162496 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 74168 | |
| S | 50419 | |
| E | 48020 | |
| C | 32512 | |
| W | 30999 | |
| U | 17751 | 6.6% |
| N | 8917 | 3.3% |
| O | 7016 | 2.6% |
Space Separator
| Value | Count | Frequency (%) |
| 141738 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1449006 | |
| Common | 141738 | 8.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 185242 | |
| r | 153725 | 10.6% |
| a | 130783 | 9.0% |
| t | 118959 | 8.2% |
| o | 89178 | 6.2% |
| n | 79385 | 5.5% |
| A | 74168 | 5.1% |
| i | 73578 | 5.1% |
| s | 73038 | 5.0% |
| u | 66721 | 4.6% |
| Other values (15) | 404229 |
Common
| Value | Count | Frequency (%) |
| 141738 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1590744 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 185242 | 11.6% |
| r | 153725 | 9.7% |
| 141738 | 8.9% | |
| a | 130783 | 8.2% |
| t | 118959 | 7.5% |
| o | 89178 | 5.6% |
| n | 79385 | 5.0% |
| A | 74168 | 4.7% |
| i | 73578 | 4.6% |
| s | 73038 | 4.6% |
| Other values (16) | 470950 |
Order State
Text
| Distinct | 1081 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 36 |
|---|---|
| Median length | 31 |
| Mean length | 10.81629 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1363707 |
|---|---|
| Distinct characters | 83 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Uttar Pradesh |
|---|---|
| 2nd row | Australia del Sur |
| 3rd row | Estambul |
| 4th row | Ulán Bator |
| 5th row | Estambul |
| Value | Count | Frequency (%) |
| de | 6255 | 3.4% |
| del | 5715 | 3.1% |
| inglaterra | 4494 | 2.4% |
| california | 3935 | 2.1% |
| nueva | 3799 | 2.1% |
| isla | 3173 | 1.7% |
| francia | 3109 | 1.7% |
| san | 2776 | 1.5% |
| sur | 2299 | 1.3% |
| renania | 2195 | 1.2% |
| Other values (1163) | 146117 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 215433 | |
| n | 99116 | 7.3% |
| i | 91568 | 6.7% |
| e | 90536 | 6.6% |
| r | 81327 | 6.0% |
| o | 80150 | 5.9% |
| l | 71501 | 5.2% |
| 57788 | 4.2% | |
| t | 55573 | 4.1% |
| s | 52662 | 3.9% |
| Other values (73) | 468053 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1101198 | |
| Uppercase Letter | 186721 | 13.7% |
| Space Separator | 57788 | 4.2% |
| Dash Punctuation | 16592 | 1.2% |
| Other Punctuation | 470 | < 0.1% |
| Close Punctuation | 469 | < 0.1% |
| Open Punctuation | 469 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 215433 | |
| n | 99116 | |
| i | 91568 | |
| e | 90536 | |
| r | 81327 | 7.4% |
| o | 80150 | 7.3% |
| l | 71501 | 6.5% |
| t | 55573 | 5.0% |
| s | 52662 | 4.8% |
| u | 43549 | 4.0% |
| Other values (35) | 219783 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 21157 | 11.3% |
| S | 19091 | 10.2% |
| A | 14257 | 7.6% |
| P | 12919 | 6.9% |
| M | 11661 | 6.2% |
| N | 10990 | 5.9% |
| I | 9675 | 5.2% |
| B | 8774 | 4.7% |
| G | 8680 | 4.6% |
| L | 7851 | 4.2% |
| Other values (22) | 61666 |
Other Punctuation
| Value | Count | Frequency (%) |
| ? | 377 | |
| ' | 93 | 19.8% |
Space Separator
| Value | Count | Frequency (%) |
| 57788 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 16592 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 469 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 469 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1287919 | |
| Common | 75788 | 5.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 215433 | |
| n | 99116 | 7.7% |
| i | 91568 | 7.1% |
| e | 90536 | 7.0% |
| r | 81327 | 6.3% |
| o | 80150 | 6.2% |
| l | 71501 | 5.6% |
| t | 55573 | 4.3% |
| s | 52662 | 4.1% |
| u | 43549 | 3.4% |
| Other values (67) | 406504 |
Common
| Value | Count | Frequency (%) |
| 57788 | ||
| - | 16592 | 21.9% |
| ) | 469 | 0.6% |
| ( | 469 | 0.6% |
| ? | 377 | 0.5% |
| ' | 93 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1337585 | |
| None | 26122 | 1.9% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 215433 | |
| n | 99116 | 7.4% |
| i | 91568 | 6.8% |
| e | 90536 | 6.8% |
| r | 81327 | 6.1% |
| o | 80150 | 6.0% |
| l | 71501 | 5.3% |
| 57788 | 4.3% | |
| t | 55573 | 4.2% |
| s | 52662 | 3.9% |
| Other values (48) | 441931 |
None
| Value | Count | Frequency (%) |
| í | 8248 | |
| á | 7097 | |
| ó | 3196 | 12.2% |
| é | 2372 | 9.1% |
| ñ | 2159 | 8.3% |
| ã | 1476 | 5.7% |
| ú | 632 | 2.4% |
| ü | 256 | 1.0% |
| à | 124 | 0.5% |
| ô | 122 | 0.5% |
| Other values (15) | 440 | 1.7% |
Order Status
Categorical
HIGH CORRELATION
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| COMPLETE | |
|---|---|
| PENDING_PAYMENT | |
| PROCESSING | |
| PENDING | |
| CLOSED | |
| Other values (4) |
Length
| Max length | 15 |
|---|---|
| Median length | 14 |
| Mean length | 9.6215309 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1213073 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PENDING_PAYMENT |
|---|---|
| 2nd row | PENDING_PAYMENT |
| 3rd row | PENDING_PAYMENT |
| 4th row | PENDING_PAYMENT |
| 5th row | PENDING_PAYMENT |
Common Values
| Value | Count | Frequency (%) |
| COMPLETE | 41586 | |
| PENDING_PAYMENT | 27805 | |
| PROCESSING | 15196 | 12.1% |
| PENDING | 14151 | 11.2% |
| CLOSED | 13651 | 10.8% |
| ON_HOLD | 6927 | 5.5% |
| SUSPECTED_FRAUD | 2834 | 2.2% |
| CANCELED | 2603 | 2.1% |
| PAYMENT_REVIEW | 1326 | 1.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| complete | 41586 | |
| pending_payment | 27805 | |
| processing | 15196 | 12.1% |
| pending | 14151 | 11.2% |
| closed | 13651 | 10.8% |
| on_hold | 6927 | 5.5% |
| suspected_fraud | 2834 | 2.2% |
| canceled | 2603 | 2.1% |
| payment_review | 1326 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 196632 | |
| N | 137769 | |
| P | 130703 | |
| O | 84287 | 6.9% |
| C | 78473 | 6.5% |
| T | 73551 | 6.1% |
| D | 70805 | 5.8% |
| M | 70717 | 5.8% |
| L | 64767 | 5.3% |
| I | 58478 | 4.8% |
| Other values (11) | 246891 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1174181 | |
| Connector Punctuation | 38892 | 3.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 196632 | |
| N | 137769 | |
| P | 130703 | |
| O | 84287 | |
| C | 78473 | 6.7% |
| T | 73551 | 6.3% |
| D | 70805 | 6.0% |
| M | 70717 | 6.0% |
| L | 64767 | 5.5% |
| I | 58478 | 5.0% |
| Other values (10) | 207999 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 38892 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1174181 | |
| Common | 38892 | 3.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 196632 | |
| N | 137769 | |
| P | 130703 | |
| O | 84287 | |
| C | 78473 | 6.7% |
| T | 73551 | 6.3% |
| D | 70805 | 6.0% |
| M | 70717 | 6.0% |
| L | 64767 | 5.5% |
| I | 58478 | 5.0% |
| Other values (10) | 207999 |
Common
| Value | Count | Frequency (%) |
| _ | 38892 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1213073 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 196632 | |
| N | 137769 | |
| P | 130703 | |
| O | 84287 | 6.9% |
| C | 78473 | 6.5% |
| T | 73551 | 6.1% |
| D | 70805 | 5.8% |
| M | 70717 | 5.8% |
| L | 64767 | 5.3% |
| I | 58478 | 4.8% |
| Other values (11) | 246891 |
Product Name
Text
| Distinct | 94 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 45 |
|---|---|
| Median length | 43 |
| Mean length | 34.123557 |
| Min length | 5 |
Characters and Unicode
| Total characters | 4302264 |
|---|---|
| Distinct characters | 64 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Perfect Fitness Perfect Rip Deck |
|---|---|
| 2nd row | Nike Men's Dri-FIT Victory Golf Polo |
| 3rd row | Under Armour Girls' Toddler Spine Surge Runni |
| 4th row | Nike Men's Dri-FIT Victory Golf Polo |
| 5th row | Nike Men's Dri-FIT Victory Golf Polo |
| Value | Count | Frequency (%) |
| men's | 65544 | 9.0% |
| nike | 47100 | 6.5% |
| perfect | 42930 | 5.9% |
| golf | 23969 | 3.3% |
| fitness | 21465 | 3.0% |
| deck | 21465 | 3.0% |
| rip | 21465 | 3.0% |
| cleat | 20779 | 2.9% |
| 2 | 20577 | 2.8% |
| elite | 20321 | 2.8% |
| Other values (284) | 419711 |
Most occurring characters
| Value | Count | Frequency (%) |
| 600607 | 14.0% | |
| e | 518357 | 12.0% |
| i | 259918 | 6.0% |
| r | 226506 | 5.3% |
| n | 226060 | 5.3% |
| t | 199120 | 4.6% |
| o | 193827 | 4.5% |
| l | 179276 | 4.2% |
| s | 175689 | 4.1% |
| a | 118913 | 2.8% |
| Other values (54) | 1603991 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2683859 | |
| Uppercase Letter | 805096 | 18.7% |
| Space Separator | 600607 | 14.0% |
| Other Punctuation | 104578 | 2.4% |
| Decimal Number | 81113 | 1.9% |
| Dash Punctuation | 20958 | 0.5% |
| Math Symbol | 6053 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 81844 | 10.2% |
| F | 71327 | 8.9% |
| M | 68656 | 8.5% |
| N | 67135 | 8.3% |
| D | 64467 | 8.0% |
| T | 58194 | 7.2% |
| S | 49470 | 6.1% |
| C | 44845 | 5.6% |
| G | 41417 | 5.1% |
| R | 39244 | 4.9% |
| Other values (15) | 218497 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 518357 | |
| i | 259918 | |
| r | 226506 | |
| n | 226060 | |
| t | 199120 | 7.4% |
| o | 193827 | 7.2% |
| l | 179276 | 6.7% |
| s | 175689 | 6.5% |
| a | 118913 | 4.4% |
| c | 105602 | 3.9% |
| Other values (14) | 480591 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 35134 | |
| 2 | 21070 | |
| 1 | 15737 | |
| 5 | 6485 | 8.0% |
| 6 | 1139 | 1.4% |
| 4 | 535 | 0.7% |
| 8 | 516 | 0.6% |
| 3 | 497 | 0.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 97542 | |
| . | 6744 | 6.4% |
| / | 261 | 0.2% |
| & | 31 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 600607 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 20958 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 6053 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3488955 | |
| Common | 813309 | 18.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 518357 | |
| i | 259918 | 7.4% |
| r | 226506 | 6.5% |
| n | 226060 | 6.5% |
| t | 199120 | 5.7% |
| o | 193827 | 5.6% |
| l | 179276 | 5.1% |
| s | 175689 | 5.0% |
| a | 118913 | 3.4% |
| c | 105602 | 3.0% |
| Other values (39) | 1285687 |
Common
| Value | Count | Frequency (%) |
| 600607 | ||
| ' | 97542 | 12.0% |
| 0 | 35134 | 4.3% |
| 2 | 21070 | 2.6% |
| - | 20958 | 2.6% |
| 1 | 15737 | 1.9% |
| . | 6744 | 0.8% |
| 5 | 6485 | 0.8% |
| + | 6053 | 0.7% |
| 6 | 1139 | 0.1% |
| Other values (5) | 1840 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4302264 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 600607 | 14.0% | |
| e | 518357 | 12.0% |
| i | 259918 | 6.0% |
| r | 226506 | 5.3% |
| n | 226060 | 5.3% |
| t | 199120 | 4.6% |
| o | 193827 | 4.5% |
| l | 179276 | 4.2% |
| s | 175689 | 4.1% |
| a | 118913 | 2.8% |
| Other values (54) | 1603991 |
Product Price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 57 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83.329405 |
| Minimum | 9.9899998 |
|---|---|
| Maximum | 249.99001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 9.9899998 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 49.98 |
| median | 59.990002 |
| Q3 | 129.99001 |
| 95-th percentile | 199.99001 |
| Maximum | 249.99001 |
| Range | 240.00001 |
| Interquartile range (IQR) | 80.010006 |
Descriptive statistics
| Standard deviation | 54.526666 |
|---|---|
| Coefficient of variation (CV) | 0.65435084 |
| Kurtosis | -0.019828239 |
| Mean | 83.329405 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 1.1008913 |
| Sum | 10506088 |
| Variance | 2973.1573 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 59.99000168 | 21733 | |
| 129.9900055 | 20385 | |
| 50 | 19114 | |
| 49.97999954 | 17483 | |
| 199.9900055 | 14084 | |
| 39.99000168 | 10366 | |
| 99.98999786 | 6186 | 4.9% |
| 24.98999977 | 2231 | 1.8% |
| 31.98999977 | 1373 | 1.1% |
| 30 | 861 | 0.7% |
| Other values (47) | 12263 |
| Value | Count | Frequency (%) |
| 9.989999771 | 280 | 0.2% |
| 11.28999996 | 271 | 0.2% |
| 11.53999996 | 529 | 0.4% |
| 14.98999977 | 576 | 0.5% |
| 15.98999977 | 583 | 0.5% |
| 17.98999977 | 293 | 0.2% |
| 19.98999977 | 859 | 0.7% |
| 21.98999977 | 283 | 0.2% |
| 22 | 297 | 0.2% |
| 24.98999977 | 2231 |
| Value | Count | Frequency (%) |
| 249.9900055 | 110 | 0.1% |
| 215.8200073 | 598 | 0.5% |
| 210.8500061 | 183 | 0.1% |
| 209.9900055 | 56 | < 0.1% |
| 199.9900055 | 14084 | |
| 199 | 61 | < 0.1% |
| 189 | 57 | < 0.1% |
| 179.9900055 | 57 | < 0.1% |
| 169.9900055 | 59 | < 0.1% |
| 164.3800049 | 432 | 0.3% |
Shipping Mode
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 6872 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.821033 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1616463 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Second Class |
|---|---|
| 2nd row | Second Class |
| 3rd row | Second Class |
| 4th row | Second Class |
| 5th row | Second Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 75188 | |
| Second Class | 24646 | 19.5% |
| First Class | 19373 | 15.4% |
| Same Day | 6872 | 5.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 119207 | |
| standard | 75188 | |
| second | 24646 | 9.8% |
| first | 19373 | 7.7% |
| same | 6872 | 2.7% |
| day | 6872 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 283327 | |
| s | 257787 | |
| d | 175022 | |
| 126079 | ||
| l | 119207 | |
| C | 119207 | |
| S | 106706 | 6.6% |
| n | 99834 | 6.2% |
| r | 94561 | 5.8% |
| t | 94561 | 5.8% |
| Other values (8) | 140172 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1238226 | |
| Uppercase Letter | 252158 | 15.6% |
| Space Separator | 126079 | 7.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 283327 | |
| s | 257787 | |
| d | 175022 | |
| l | 119207 | |
| n | 99834 | 8.1% |
| r | 94561 | 7.6% |
| t | 94561 | 7.6% |
| e | 31518 | 2.5% |
| c | 24646 | 2.0% |
| o | 24646 | 2.0% |
| Other values (3) | 33117 | 2.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 119207 | |
| S | 106706 | |
| F | 19373 | 7.7% |
| D | 6872 | 2.7% |
Space Separator
| Value | Count | Frequency (%) |
| 126079 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1490384 | |
| Common | 126079 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 283327 | |
| s | 257787 | |
| d | 175022 | |
| l | 119207 | |
| C | 119207 | |
| S | 106706 | 7.2% |
| n | 99834 | 6.7% |
| r | 94561 | 6.3% |
| t | 94561 | 6.3% |
| e | 31518 | 2.1% |
| Other values (7) | 108654 | 7.3% |
Common
| Value | Count | Frequency (%) |
| 126079 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1616463 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 283327 | |
| s | 257787 | |
| d | 175022 | |
| 126079 | ||
| l | 119207 | |
| C | 119207 | |
| S | 106706 | 6.6% |
| n | 99834 | 6.2% |
| r | 94561 | 5.8% |
| t | 94561 | 5.8% |
| Other values (8) | 140172 |
| Benefit per order | Category Name | Customer Country | Customer Id | Customer Segment | Customer State | Days for shipment (scheduled) | Days for shipping (real) | Delivery Status | Department Name | Late_delivery_risk | Market | Order Item Discount | Order Item Product Price | Order Item Quantity | Order Item Total | Order Profit Per Order | Order Region | Order Status | Product Price | Sales | Sales per customer | Shipping Mode | Type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Benefit per order | 1.000 | 0.151 | 0.000 | -0.030 | 0.000 | 0.001 | 0.001 | -0.000 | 0.000 | 0.095 | 0.001 | 0.021 | 0.199 | 0.218 | 0.220 | 0.521 | 1.000 | 0.014 | 0.002 | 0.218 | 0.513 | 0.521 | 0.001 | 0.002 |
| Category Name | 0.151 | 1.000 | 0.000 | 0.505 | 0.011 | 0.005 | 0.015 | 0.005 | 0.000 | 0.990 | 0.002 | 0.152 | 0.137 | 0.873 | 0.367 | 0.404 | 0.151 | 0.073 | 0.000 | 0.873 | 0.508 | 0.404 | 0.015 | 0.000 |
| Customer Country | 0.000 | 0.000 | 1.000 | 0.013 | 0.016 | 1.000 | 0.010 | 0.010 | 0.004 | 0.000 | 0.000 | 0.013 | 0.003 | 0.000 | 0.000 | 0.005 | 0.000 | 0.016 | 0.008 | 0.000 | 0.006 | 0.005 | 0.010 | 0.007 |
| Customer Id | -0.030 | 0.505 | 0.013 | 1.000 | 0.033 | 0.050 | 0.013 | -0.000 | 0.007 | 0.360 | 0.000 | 0.154 | -0.028 | -0.015 | 0.095 | -0.044 | -0.030 | 0.116 | 0.010 | -0.015 | -0.043 | -0.044 | 0.013 | 0.004 |
| Customer Segment | 0.000 | 0.011 | 0.016 | 0.033 | 1.000 | 0.062 | 0.008 | 0.011 | 0.005 | 0.005 | 0.000 | 0.002 | 0.000 | 0.003 | 0.005 | 0.007 | 0.000 | 0.018 | 0.010 | 0.003 | 0.007 | 0.007 | 0.008 | 0.004 |
| Customer State | 0.001 | 0.005 | 1.000 | 0.050 | 0.062 | 1.000 | 0.031 | 0.028 | 0.026 | 0.010 | 0.018 | 0.031 | 0.000 | 0.000 | 0.000 | 0.005 | 0.001 | 0.026 | 0.023 | 0.000 | 0.000 | 0.005 | 0.031 | 0.023 |
| Days for shipment (scheduled) | 0.001 | 0.015 | 0.010 | 0.013 | 0.008 | 0.031 | 1.000 | 0.681 | 0.321 | 0.011 | 0.457 | 0.006 | 0.000 | 0.000 | 0.003 | 0.000 | 0.001 | 0.023 | 0.007 | 0.000 | 0.000 | 0.000 | 1.000 | 0.006 |
| Days for shipping (real) | -0.000 | 0.005 | 0.010 | -0.000 | 0.011 | 0.028 | 0.681 | 1.000 | 0.561 | 0.008 | 0.632 | 0.007 | 0.001 | -0.002 | 0.000 | -0.001 | -0.000 | 0.022 | 0.008 | -0.002 | -0.001 | -0.001 | 0.681 | 0.010 |
| Delivery Status | 0.000 | 0.000 | 0.004 | 0.007 | 0.005 | 0.026 | 0.321 | 0.561 | 1.000 | 0.004 | 1.000 | 0.007 | 0.000 | 0.000 | 0.000 | 0.002 | 0.000 | 0.018 | 0.577 | 0.000 | 0.000 | 0.002 | 0.321 | 0.199 |
| Department Name | 0.095 | 0.990 | 0.000 | 0.360 | 0.005 | 0.010 | 0.011 | 0.008 | 0.004 | 1.000 | 0.002 | 0.101 | 0.092 | 0.579 | 0.199 | 0.286 | 0.095 | 0.082 | 0.000 | 0.579 | 0.361 | 0.286 | 0.011 | 0.000 |
| Late_delivery_risk | 0.001 | 0.002 | 0.000 | 0.000 | 0.000 | 0.018 | 0.457 | 0.632 | 1.000 | 0.002 | 1.000 | 0.006 | 0.005 | 0.004 | 0.000 | 0.006 | 0.001 | 0.016 | 0.234 | 0.004 | 0.000 | 0.006 | 0.457 | 0.080 |
| Market | 0.021 | 0.152 | 0.013 | 0.154 | 0.002 | 0.031 | 0.006 | 0.007 | 0.007 | 0.101 | 0.006 | 1.000 | 0.014 | 0.086 | 0.024 | 0.049 | 0.021 | 1.000 | 0.011 | 0.086 | 0.054 | 0.049 | 0.006 | 0.012 |
| Order Item Discount | 0.199 | 0.137 | 0.003 | -0.028 | 0.000 | 0.000 | 0.000 | 0.001 | 0.000 | 0.092 | 0.005 | 0.014 | 1.000 | 0.217 | 0.189 | 0.326 | 0.199 | 0.011 | 0.000 | 0.217 | 0.478 | 0.326 | 0.000 | 0.000 |
| Order Item Product Price | 0.218 | 0.873 | 0.000 | -0.015 | 0.003 | 0.000 | 0.000 | -0.002 | 0.000 | 0.579 | 0.004 | 0.086 | 0.217 | 1.000 | 0.356 | 0.370 | 0.218 | 0.064 | 0.004 | 1.000 | 0.402 | 0.370 | 0.000 | 0.000 |
| Order Item Quantity | 0.220 | 0.367 | 0.000 | 0.095 | 0.005 | 0.000 | 0.003 | 0.000 | 0.000 | 0.199 | 0.000 | 0.024 | 0.189 | 0.356 | 1.000 | 0.491 | 0.220 | 0.028 | 0.000 | 0.356 | 0.593 | 0.491 | 0.003 | 0.000 |
| Order Item Total | 0.521 | 0.404 | 0.005 | -0.044 | 0.007 | 0.005 | 0.000 | -0.001 | 0.002 | 0.286 | 0.006 | 0.049 | 0.326 | 0.370 | 0.491 | 1.000 | 0.521 | 0.036 | 0.005 | 0.370 | 0.978 | 1.000 | 0.000 | 0.003 |
| Order Profit Per Order | 1.000 | 0.151 | 0.000 | -0.030 | 0.000 | 0.001 | 0.001 | -0.000 | 0.000 | 0.095 | 0.001 | 0.021 | 0.199 | 0.218 | 0.220 | 0.521 | 1.000 | 0.014 | 0.002 | 0.218 | 0.513 | 0.521 | 0.001 | 0.002 |
| Order Region | 0.014 | 0.073 | 0.016 | 0.116 | 0.018 | 0.026 | 0.023 | 0.022 | 0.018 | 0.082 | 0.016 | 1.000 | 0.011 | 0.064 | 0.028 | 0.036 | 0.014 | 1.000 | 0.018 | 0.064 | 0.040 | 0.036 | 0.023 | 0.021 |
| Order Status | 0.002 | 0.000 | 0.008 | 0.010 | 0.010 | 0.023 | 0.007 | 0.008 | 0.577 | 0.000 | 0.234 | 0.011 | 0.000 | 0.004 | 0.000 | 0.005 | 0.002 | 0.018 | 1.000 | 0.004 | 0.002 | 0.005 | 0.007 | 1.000 |
| Product Price | 0.218 | 0.873 | 0.000 | -0.015 | 0.003 | 0.000 | 0.000 | -0.002 | 0.000 | 0.579 | 0.004 | 0.086 | 0.217 | 1.000 | 0.356 | 0.370 | 0.218 | 0.064 | 0.004 | 1.000 | 0.402 | 0.370 | 0.000 | 0.000 |
| Sales | 0.513 | 0.508 | 0.006 | -0.043 | 0.007 | 0.000 | 0.000 | -0.001 | 0.000 | 0.361 | 0.000 | 0.054 | 0.478 | 0.402 | 0.593 | 0.978 | 0.513 | 0.040 | 0.002 | 0.402 | 1.000 | 0.978 | 0.000 | 0.002 |
| Sales per customer | 0.521 | 0.404 | 0.005 | -0.044 | 0.007 | 0.005 | 0.000 | -0.001 | 0.002 | 0.286 | 0.006 | 0.049 | 0.326 | 0.370 | 0.491 | 1.000 | 0.521 | 0.036 | 0.005 | 0.370 | 0.978 | 1.000 | 0.000 | 0.003 |
| Shipping Mode | 0.001 | 0.015 | 0.010 | 0.013 | 0.008 | 0.031 | 1.000 | 0.681 | 0.321 | 0.011 | 0.457 | 0.006 | 0.000 | 0.000 | 0.003 | 0.000 | 0.001 | 0.023 | 0.007 | 0.000 | 0.000 | 0.000 | 1.000 | 0.006 |
| Type | 0.002 | 0.000 | 0.007 | 0.004 | 0.004 | 0.023 | 0.006 | 0.010 | 0.199 | 0.000 | 0.080 | 0.012 | 0.000 | 0.000 | 0.000 | 0.003 | 0.002 | 0.021 | 1.000 | 0.000 | 0.002 | 0.003 | 0.006 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Type | Days for shipping (real) | Days for shipment (scheduled) | Benefit per order | Sales per customer | Delivery Status | Late_delivery_risk | Category Name | Customer City | Customer Country | Customer Id | Customer Segment | Customer State | Department Name | Market | Order City | Order Country | Order Item Discount | Order Item Product Price | Order Item Quantity | Sales | Order Item Total | Order Profit Per Order | Order Region | Order State | Order Status | Product Name | Product Price | Shipping Mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48 | PAYMENT | 5 | 2 | -30.750000 | 115.180000 | Late delivery | 1 | Cleats | Bayamon | Puerto Rico | 9083 | Home Office | PR | Apparel | Pacific Asia | Mirzapur | India | 4.800000 | 59.990002 | 2 | 119.980003 | 115.180000 | -30.750000 | South Asia | Uttar Pradesh | PENDING_PAYMENT | Perfect Fitness Perfect Rip Deck | 59.990002 | Second Class |
| 50 | PAYMENT | 6 | 2 | 33.599998 | 96.000000 | Late delivery | 1 | Women's Apparel | Caguas | Puerto Rico | 639 | Home Office | PR | Golf | Pacific Asia | Murray Bridge | Australia | 4.000000 | 50.000000 | 2 | 100.000000 | 96.000000 | 33.599998 | Oceania | Australia del Sur | PENDING_PAYMENT | Nike Men's Dri-FIT Victory Golf Polo | 50.000000 | Second Class |
| 51 | PAYMENT | 2 | 2 | 24.690001 | 75.980003 | Shipping on time | 0 | Shop By Sport | Caguas | Puerto Rico | 9702 | Home Office | PR | Golf | Pacific Asia | Kartal | Turquía | 4.000000 | 39.990002 | 2 | 79.980003 | 75.980003 | 24.690001 | West Asia | Estambul | PENDING_PAYMENT | Under Armour Girls' Toddler Spine Surge Runni | 39.990002 | Second Class |
| 52 | PAYMENT | 3 | 2 | 9.100000 | 91.000000 | Late delivery | 1 | Women's Apparel | Caguas | Puerto Rico | 9114 | Home Office | PR | Golf | Pacific Asia | Ulan Bator | Mongolia | 9.000000 | 50.000000 | 2 | 100.000000 | 91.000000 | 9.100000 | Eastern Asia | Ulán Bator | PENDING_PAYMENT | Nike Men's Dri-FIT Victory Golf Polo | 50.000000 | Second Class |
| 53 | PAYMENT | 5 | 2 | -21.750000 | 87.000000 | Late delivery | 1 | Women's Apparel | Caguas | Puerto Rico | 1362 | Home Office | PR | Golf | Pacific Asia | Estambul | Turquía | 13.000000 | 50.000000 | 2 | 100.000000 | 87.000000 | -21.750000 | West Asia | Estambul | PENDING_PAYMENT | Nike Men's Dri-FIT Victory Golf Polo | 50.000000 | Second Class |
| 54 | PAYMENT | 6 | 2 | 6.150000 | 82.000000 | Late delivery | 1 | Women's Apparel | Caguas | Puerto Rico | 8011 | Home Office | PR | Golf | Pacific Asia | Raipur | India | 18.000000 | 50.000000 | 2 | 100.000000 | 82.000000 | 6.150000 | South Asia | Rajastán | PENDING_PAYMENT | Nike Men's Dri-FIT Victory Golf Polo | 50.000000 | Second Class |
| 55 | PAYMENT | 2 | 2 | 22.410000 | 74.680000 | Shipping on time | 0 | Electronics | Caguas | Puerto Rico | 3296 | Home Office | PR | Footwear | USCA | Pasco | Estados Unidos | 15.300000 | 44.990002 | 2 | 89.980003 | 74.680000 | 22.410000 | West of USA | Washington | PENDING_PAYMENT | Under Armour Men's Compression EV SL Slide | 44.990002 | Second Class |
| 56 | PAYMENT | 5 | 2 | 25.240000 | 90.150002 | Late delivery | 1 | Boxing & MMA | Caguas | Puerto Rico | 3182 | Home Office | PR | Footwear | USCA | Los Angeles | Estados Unidos | 19.790001 | 54.970001 | 2 | 109.940002 | 90.150002 | 25.240000 | West of USA | California | PENDING_PAYMENT | Under Armour Women's Micro G Skulpt Running S | 54.970001 | Second Class |
| 57 | PAYMENT | 6 | 2 | 30.570000 | 117.580002 | Late delivery | 1 | Cleats | Caguas | Puerto Rico | 7864 | Home Office | PR | Apparel | USCA | San Francisco | Estados Unidos | 2.400000 | 59.990002 | 2 | 119.980003 | 117.580002 | 30.570000 | West of USA | California | PENDING_PAYMENT | Perfect Fitness Perfect Rip Deck | 59.990002 | Second Class |
| 58 | PAYMENT | 4 | 2 | 46.070000 | 95.980003 | Late delivery | 1 | Cleats | Caguas | Puerto Rico | 11169 | Home Office | PR | Apparel | USCA | Overland Park | Estados Unidos | 24.000000 | 59.990002 | 2 | 119.980003 | 95.980003 | 46.070000 | US Center | Kansas | PENDING_PAYMENT | Perfect Fitness Perfect Rip Deck | 59.990002 | Second Class |
| Type | Days for shipping (real) | Days for shipment (scheduled) | Benefit per order | Sales per customer | Delivery Status | Late_delivery_risk | Category Name | Customer City | Customer Country | Customer Id | Customer Segment | Customer State | Department Name | Market | Order City | Order Country | Order Item Discount | Order Item Product Price | Order Item Quantity | Sales | Order Item Total | Order Profit Per Order | Order Region | Order State | Order Status | Product Name | Product Price | Shipping Mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179619 | TRANSFER | 2 | 4 | 72.889999 | 269.959992 | Advance shipping | 0 | Cleats | Caguas | Puerto Rico | 11659 | Consumer | PR | Apparel | LATAM | Tegucigalpa | Honduras | 30.000000 | 59.990002 | 5 | 299.950012 | 269.959992 | 72.889999 | Central America | Francisco Morazán | PENDING | Perfect Fitness Perfect Rip Deck | 59.990002 | Standard Class |
| 179620 | TRANSFER | 5 | 4 | -53.990002 | 269.959992 | Late delivery | 1 | Cleats | Caguas | Puerto Rico | 5907 | Consumer | PR | Apparel | LATAM | Masaya | Nicaragua | 30.000000 | 59.990002 | 5 | 299.950012 | 269.959992 | -53.990002 | Central America | Masaya | PENDING | Perfect Fitness Perfect Rip Deck | 59.990002 | Standard Class |
| 179621 | TRANSFER | 3 | 4 | -26.100000 | 260.959992 | Advance shipping | 0 | Cleats | Juana Diaz | Puerto Rico | 10344 | Consumer | PR | Apparel | LATAM | Villahermosa | México | 38.990002 | 59.990002 | 5 | 299.950012 | 260.959992 | -26.100000 | Central America | Tabasco | PENDING | Perfect Fitness Perfect Rip Deck | 59.990002 | Standard Class |
| 179622 | TRANSFER | 4 | 4 | 81.680000 | 260.959992 | Shipping on time | 0 | Cleats | Caguas | Puerto Rico | 8386 | Consumer | PR | Apparel | LATAM | Managua | Nicaragua | 38.990002 | 59.990002 | 5 | 299.950012 | 260.959992 | 81.680000 | Central America | Managua | PENDING | Perfect Fitness Perfect Rip Deck | 59.990002 | Standard Class |
| 179623 | TRANSFER | 2 | 4 | 117.430000 | 260.959992 | Advance shipping | 0 | Cleats | Caguas | Puerto Rico | 8917 | Consumer | PR | Apparel | LATAM | Barueri | Brasil | 38.990002 | 59.990002 | 5 | 299.950012 | 260.959992 | 117.430000 | South America | São Paulo | PENDING | Perfect Fitness Perfect Rip Deck | 59.990002 | Standard Class |
| 179624 | TRANSFER | 3 | 4 | 48.439999 | 254.960007 | Advance shipping | 0 | Cleats | Caguas | Puerto Rico | 9204 | Consumer | PR | Apparel | LATAM | Maceió | Brasil | 44.990002 | 59.990002 | 5 | 299.950012 | 254.960007 | 48.439999 | South America | Alagoas | PENDING | Perfect Fitness Perfect Rip Deck | 59.990002 | Standard Class |
| 179625 | TRANSFER | 6 | 4 | 41.070000 | 251.960007 | Late delivery | 1 | Cleats | Caguas | Puerto Rico | 7190 | Consumer | PR | Apparel | LATAM | Santa Ana | El Salvador | 47.990002 | 59.990002 | 5 | 299.950012 | 251.960007 | 41.070000 | Central America | Santa Ana | PENDING | Perfect Fitness Perfect Rip Deck | 59.990002 | Standard Class |
| 179626 | TRANSFER | 3 | 4 | 92.110001 | 248.960007 | Advance shipping | 0 | Cleats | Caguas | Puerto Rico | 10240 | Consumer | PR | Apparel | LATAM | Choluteca | Honduras | 50.990002 | 59.990002 | 5 | 299.950012 | 248.960007 | 92.110001 | Central America | Choluteca | PENDING | Perfect Fitness Perfect Rip Deck | 59.990002 | Standard Class |
| 179627 | TRANSFER | 4 | 4 | 76.989998 | 245.960007 | Shipping on time | 0 | Cleats | Caguas | Puerto Rico | 3 | Consumer | PR | Apparel | LATAM | Tegucigalpa | Honduras | 53.990002 | 59.990002 | 5 | 299.950012 | 245.960007 | 76.989998 | Central America | Francisco Morazán | PENDING | Perfect Fitness Perfect Rip Deck | 59.990002 | Standard Class |
| 179629 | TRANSFER | 4 | 4 | 37.590000 | 199.949997 | Shipping on time | 0 | Shop By Sport | Caguas | Puerto Rico | 482 | Consumer | PR | Golf | LATAM | La Romana | República Dominicana | 0.000000 | 39.990002 | 5 | 199.949997 | 199.949997 | 37.590000 | Caribbean | La Romana | PENDING | Under Armour Girls' Toddler Spine Surge Runni | 39.990002 | Standard Class |